# Prerequisites

Before designing a task with HP NonStop SQL/MP as an ODBC Target, the following prerequisites must be met:

* All source tables and their indexes must already exist on the target database.

* The default name for the Replicate Apply Exceptions table (`attrep_apply_exceptions`) is not compliant with HP NonStop SQL/MP table naming conventions which dictate that table names cannot exceed 8 characters or contain non-alphanumeric characters. To resolve this conflict, you need to add the following entry to your NAVMAP file or create a new NAVMAP file (The NAVMAP file is located in the subvolume where ARC is installed):

  Syntax:

  `[SQLMP]`

  attrep\_apply\_exceptions= \machine\_name.$volume\_name.subvolume\_name.atreapex

  You also need to manually create the Apply Exceptions table on the HP NonStop SQL/MP target *before starting the task*. The table should be named `atreapex` and should contain the following columns:

  Column name data types

  | Column name | Data type |
  | --- | --- |
  | TASK\_NAME | Varchar(128) |
  | TABLE\_OWNER | Varchar(128) |
  | TABLE\_NAME | Varchar(128) |
  | ERRORTIME | Datetime year to fraction |
  | STATEMENT | Varchar(1000) |
  | ERROR | Varchar(1000) |

* If you intend to enable the Replicate Store Changes option, you need to manually create the audit table on the HP NonStop SQL/MP target before starting the task.

  Information note

  This also requires you make the following changes in the [Store Changes Settings](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/store_changes_settings.htm) tab:

  1. Select Audit table from the Store changes drop-down list.

  2. Change the default audit table name from `attrep_audit_table` to `atreauta`.

  Create a table named `atreauta` with the following parameters:

  Parameter data types

  | Column Name | Data Type |
  | --- | --- |
  | \*task\_name | Varchar(110) |
  | \*stream\_position | Varchar(128) |
  | change\_seq | Varchar(35) |
  | change\_oper | Varchar(1) |
  | schema\_name | Varchar(128) |
  | table\_name | Varchar(128) |
  | operation | Varchar(12) |
  | transaction\_id | Varchar(32) |
  | timestamp | Timestamp |
  | change\_record | Varchar(1000) |
  | bu\_change\_record | Varchar(1000) |

  Information note

  : You also need to create a Unique Index consisting of the task\_name and stream\_position columns (marked with an asterisk above).